create or replace procedure getVdnLog(p_cusor  out sys_refcursor, p_code   in varchar2) is

begin
open p_cusor for select * from dc_sys_menu where node_code like p_code;

  
end getVdnLog;


/

create or replace procedure getVdnLogPage(p_totalcount out integer,p_cusor  out sys_refcursor,p_code   in varchar2) is

begin

select count(*) into p_totalcount from dc_sys_menu where node_code like p_code;
if (p_totalcount>0)  then
    
     open p_cusor for select * from dc_sys_menu where node_code like p_code;
end if;

end getVdnLogPage;

